{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/emattiacci/Dropbox/Vigilantism_Paper2/Code/Replication Files/Untitled.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 2 Feb 2018, 16:08:27

{com}. do "/var/folders/70/mj39p0fd0f749tnbykb3x8hcw2k4d6/T//SD11804.000000"
{txt}
{com}. ************************************************************************************************************
. * Keeping Vigil: The Emergence of Vigilance Committees in Pre-Civil War America.  *
. * Jonathan Obert & Eleonora Mattiacci                                             *
. * Last modified: January 31, 2018   
. ************************************************************************************************************
. 
. *Code to replicate Table 3, descriptive statistics, in the Appendix
. *The analysis was carried out on Stata v 14.2 on a 3.5 GHz Intel Core i7 running OS Sierra 10.12.6
. 
. *Set the working directory
. cd "~/Dropbox/Vigilantism Paper/"
{res}/Users/emattiacci/Dropbox/Vigilantism Paper
{txt}
{com}. *Load data
. use "data_replication.dta", clear
{txt}
{com}. *Drop if multiple==1
. drop if multiple==1
{txt}(35 observations deleted)

{com}. *Find and install the p
. ssc install  sutex2
{txt}checking {hilite:sutex2} consistency and verifying not already installed...
all files already exist and are up to date.

{com}. *Run this command for a Latex ready table
. sutex2 committee ef_i bre  gini_i manu_i urb_i sla_i, minmax  percentiles(25,75) caption(Descriptive Statistics) tablab(Des)
%------- Begin LaTeX code -------%
\begin{table}[htbp]\centering \caption{Descriptive Statistics\label{Des}}
\begin{tabular}{l c c c c c c c}\hline\hline
\multicolumn{1}{c}{Variable} & Obs & Mean & Std. Dev.
 & Min & Max & P25 & P75  \\ \hline
committee & 19887 & .002 & .048 & 0 & 1 & 0 & 0 \\
ef\_i & 17434 & 10.849 & 13.058 & 0 & 50 & 1.136 & 15.961 \\
bre & 19883 & .161 & .368 & 0 & 1 & 0 & 0 \\
gini\_i & 16158 & 44.884 & 15.545 & 0 & 88.774 & 36.841 & 55.16 \\
manu\_i & 16185 & 1.991 & 3.414 & 0 & 76.342 & .441 & 2.11 \\
urb\_i & 17491 & 4.48 & 13.599 & 0 & 100 & 0 & 0 \\
sla\_i & 11148 & 27.179 & 21.953 & 0 & 93.408 & 7.546 & 44.306 \\
\hline
\end{tabular}
\end{table}
%------- End LaTeX code -------%
{txt}
{com}. 
{txt}end of do-file

{com}. do "/var/folders/70/mj39p0fd0f749tnbykb3x8hcw2k4d6/T//SD11804.000000"
{txt}
{com}. ************************************************************************************************************
. * Keeping Vigil: The Emergence of Vigilance Committees in Pre-Civil War America.  *
. * Jonathan Obert & Eleonora Mattiacci                                             *
. * Last modified: January 31, 2018   
. ************************************************************************************************************
. 
. ************************************************************************************************************
. * Code to replicate Table 5, descriptive statistics, in the Appendix                                       *
. * The analysis was carried out on Stata v 14.2 on a 3.5 GHz Intel Core i7 running OS Sierra 10.12.6        *
. ************************************************************************************************************
. 
. *use "/Users/emattiacci/Dropbox/Vigilantism_Paper2/Multiple Imputations 2017/outdataARR.dta", clear
. 
. *Set the working directory
. cd "~/Dropbox/Vigilantism_Paper2/Code/Replication Files/"
{res}/Users/emattiacci/Dropbox/Vigilantism_Paper2/Code/Replication Files
{txt}
{com}. *Load data
. use "MI.dta", clear
{txt}
{com}. 
. set seed 123
{txt}
{com}. 
. mi import flong, m(blah) id(active_year fips) imputed(ethnic_frac_2NA gini_1850_2NA manufacturing_2NA slavery_2NA border_revision_2year)
{res}{txt}{p}
(17517 {it:m}=0 obs. now marked as incomplete)
{p_end}

{com}. 
. 
. mi passive: generate interaction2 = ethnic_frac_2NA*border_revision_2yeardum
{res}{txt}{it:m}=0:
(16,402 missing values generated)
{it:m}=1:
{it:m}=2:
{it:m}=3:
{it:m}=4:
{it:m}=5:
{it:m}=6:
{it:m}=7:
{it:m}=8:
{it:m}=9:
{it:m}=10:
{it:m}=11:
{it:m}=12:
{it:m}=13:
{it:m}=14:
{it:m}=15:
{it:m}=16:
{it:m}=17:
{it:m}=18:
{it:m}=19:
{it:m}=20:
{it:m}=21:
{it:m}=22:
{it:m}=23:
{it:m}=24:
{it:m}=25:
{it:m}=26:
{it:m}=27:
{it:m}=28:
{it:m}=29:
{it:m}=30:
{it:m}=31:
{it:m}=32:
{it:m}=33:
{it:m}=34:
{it:m}=35:
{it:m}=36:
{it:m}=37:
{it:m}=38:
{it:m}=39:
{it:m}=40:
{it:m}=41:
{it:m}=42:
{it:m}=43:
{it:m}=44:
{it:m}=45:
{it:m}=46:
{it:m}=47:
{it:m}=48:
{it:m}=49:
{it:m}=50:
{it:m}=51:
{it:m}=52:
{it:m}=53:
{it:m}=54:
{it:m}=55:
{it:m}=56:
{it:m}=57:
{it:m}=58:
{it:m}=59:
{it:m}=60:
{it:m}=61:
{it:m}=62:
{it:m}=63:
{it:m}=64:
{it:m}=65:
{it:m}=66:
{it:m}=67:
{it:m}=68:
{it:m}=69:
{it:m}=70:
{it:m}=71:
{it:m}=72:
{it:m}=73:
{it:m}=74:
{it:m}=75:
{it:m}=76:
{it:m}=77:
{it:m}=78:
{it:m}=79:
{it:m}=80:
{it:m}=81:
{it:m}=82:
{it:m}=83:
{it:m}=84:
{it:m}=85:
{it:m}=86:
{it:m}=87:
{it:m}=88:
{it:m}=89:
{it:m}=90:
{it:m}=91:
{it:m}=92:
{it:m}=93:
{it:m}=94:
{it:m}=95:
{it:m}=96:
{it:m}=97:
{it:m}=98:
{it:m}=99:
{it:m}=100:

{com}. mi stset seq, failure(committee==1) id(fips)
{res}
                {txt}id:  {res}fips
     {txt}failure event:  {res}committee == 1
{txt}obs. time interval:  {res}(seq[_n-1], seq]
{txt} exit on or before:  {res}failure

{txt}{hline 78}
{res}      19887{txt}  total observations
{res}          0{txt}  exclusions
{hline 78}
{res}      19887{txt}  observations remaining, representing
{res}       2034{txt}  subjects
{res}         45{txt}  failures in single-failure-per-subject data
{res}      19887{txt}  total analysis time at risk and under observation
                                                at risk from t = {res}        0
                                     {txt}earliest observed entry t = {res}        0
                                          {txt}last observed exit t = {res}       11
{txt}
{com}. 
. ***Code to replicate Model 1, Table 5, in the Appendix
. mi estimate: stcox ethnic_frac_2NA border_revision_2yeardum interaction2, nohr vce(cluster fips) efron 
{res}
{txt}Multiple-imputation estimates{col 49}Imputations{col 67}= {res}       100
{txt}Cox regression: Efron method for ties{col 49}Number of obs{col 67}= {res}    19,887
{txt}{col 49}Average RVI{col 67}= {res}    0.1932
{txt}{col 49}Largest FMI{col 67}= {res}    0.1472
{txt}DF adjustment:{ralign 15: {res:Large sample}}{col 49}DF:     min{col 67}= {res}  4,590.73
{txt}{col 49}        avg{col 67}= {res}  4,910.66
{txt}{col 49}        max{col 67}= {res}  5,378.70
{txt}Model F test:{ralign 16: {res:Equal FMI}}{col 49}F({res}   3{txt},{res}11056.1{txt}){col 67}= {res}     26.97
{txt}Within VCE type: {ralign 12:{res:Robust}}{col 49}Prob > F{col 67}= {res}    0.0000

{txt}{ralign 90:(Within VCE adjusted for {res:2,034} clusters in fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}                      _t{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}ethnic_frac_2NA {c |}{col 26}{res}{space 2} 3.920466{col 38}{space 2} 1.245516{col 49}{space 1}    3.15{col 58}{space 3}0.002{col 66}{space 4} 1.478678{col 79}{space 3} 6.362254
{txt}border_revision_2yeardum {c |}{col 26}{res}{space 2} .6624473{col 38}{space 2} .4927959{col 49}{space 1}    1.34{col 58}{space 3}0.179{col 66}{space 4}-.3036697{col 79}{space 3} 1.628564
{txt}{space 12}interaction2 {c |}{col 26}{res}{space 2} 2.949715{col 38}{space 2} 1.706218{col 49}{space 1}    1.73{col 58}{space 3}0.084{col 66}{space 4}-.3951645{col 79}{space 3} 6.294594
{txt}{hline 25}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. ***Code to replicate Model 2, Table 5, in the Appendix
. 
. mi estimate: stcox ethnic_frac_2NA border_revision_2yeardum interaction2 gini_1850_2NA manufacturing_2NA urbanization_2NA slavery_2NA, nohr vce(cluster fips) efron 
{res}
{txt}Multiple-imputation estimates{col 49}Imputations{col 67}= {res}       100
{txt}Cox regression: Efron method for ties{col 49}Number of obs{col 67}= {res}    19,887
{txt}{col 49}Average RVI{col 67}= {res}    0.3298
{txt}{col 49}Largest FMI{col 67}= {res}    0.4111
{txt}DF adjustment:{ralign 15: {res:Large sample}}{col 49}DF:     min{col 67}= {res}    591.48
{txt}{col 49}        avg{col 67}= {res}  3,927.23
{txt}{col 49}        max{col 67}= {res} 11,695.33
{txt}Model F test:{ralign 16: {res:Equal FMI}}{col 49}F({res}   7{txt},{res}11157.0{txt}){col 67}= {res}     12.12
{txt}Within VCE type: {ralign 12:{res:Robust}}{col 49}Prob > F{col 67}= {res}    0.0000

{txt}{ralign 90:(Within VCE adjusted for {res:2,034} clusters in fips)}
{hline 25}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}                      _t{col 26}{c |}      Coef.{col 38}   Std. Err.{col 50}      t{col 58}   P>|t|{col 66}     [95% Con{col 79}f. Interval]
{hline 25}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}ethnic_frac_2NA {c |}{col 26}{res}{space 2} 2.732407{col 38}{space 2} 1.529161{col 49}{space 1}    1.79{col 58}{space 3}0.074{col 66}{space 4}-.2660797{col 79}{space 3} 5.730895
{txt}border_revision_2yeardum {c |}{col 26}{res}{space 2} .5355564{col 38}{space 2}   .49376{col 49}{space 1}    1.08{col 58}{space 3}0.278{col 66}{space 4}-.4324764{col 79}{space 3} 1.503589
{txt}{space 12}interaction2 {c |}{col 26}{res}{space 2} 3.324943{col 38}{space 2}  1.76315{col 49}{space 1}    1.89{col 58}{space 3}0.059{col 66}{space 4} -.131761{col 79}{space 3} 6.781648
{txt}{space 11}gini_1850_2NA {c |}{col 26}{res}{space 2}-2.452381{col 38}{space 2} 1.189785{col 49}{space 1}   -2.06{col 58}{space 3}0.040{col 66}{space 4}-4.789099{col 79}{space 3}-.1156632
{txt}{space 7}manufacturing_2NA {c |}{col 26}{res}{space 2}-2.088444{col 38}{space 2}  11.4405{col 49}{space 1}   -0.18{col 58}{space 3}0.855{col 66}{space 4}-24.51374{col 79}{space 3} 20.33685
{txt}{space 8}urbanization_2NA {c |}{col 26}{res}{space 2} 2.312641{col 38}{space 2} 1.198113{col 49}{space 1}    1.93{col 58}{space 3}0.054{col 66}{space 4}-.0364176{col 79}{space 3}   4.6617
{txt}{space 13}slavery_2NA {c |}{col 26}{res}{space 2}-.4697715{col 38}{space 2} 1.054672{col 49}{space 1}   -0.45{col 58}{space 3}0.656{col 66}{space 4}-2.540754{col 79}{space 3} 1.601212
{txt}{hline 25}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. 
{txt}end of do-file

{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/emattiacci/Dropbox/Vigilantism_Paper2/Code/Replication Files/Untitled.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 2 Feb 2018, 16:14:41
{txt}{.-}
{smcl}
{txt}{sf}{ul off}